/*
 Navicat Premium Data Transfer

 Source Server         : 本地数据库
 Source Server Type    : MySQL
 Source Server Version : 50731
 Source Host           : localhost:3306
 Source Schema         : test

 Target Server Type    : MySQL
 Target Server Version : 50731
 File Encoding         : 65001

 Date: 08/09/2021 14:24:14
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for mp_user
-- ----------------------------
DROP TABLE IF EXISTS `mp_user`;
CREATE TABLE `mp_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `create_user` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_user` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `delete_flag` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '删除标识：0-未删除，1-已删除',
  `username` varchar(50) DEFAULT NULL COMMENT '用户名',
  `password` varchar(50) DEFAULT NULL COMMENT '密码',
  `birthday` varchar(50) DEFAULT NULL COMMENT '生日',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1435066199628091395 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of mp_user
-- ----------------------------
BEGIN;
INSERT INTO `mp_user` VALUES (1, NULL, NULL, NULL, '2021-09-06 15:51:55', 0, 'lily', '123', '2019-12-12');
INSERT INTO `mp_user` VALUES (2, NULL, NULL, NULL, '2021-09-06 15:51:56', 0, 'tom', '123', '2019-12-12');
INSERT INTO `mp_user` VALUES (1435062640798867458, 'qjc', '2021-09-07 10:09:30', 'qjc', '2021-09-07 10:19:00', 0, 'lucy', '66666', '2020-01-01');
INSERT INTO `mp_user` VALUES (1435064337008955393, 'qjc', '2021-09-07 10:16:15', NULL, '2021-09-07 10:17:39', 1, 'cat', '777', '2021-01-01');
INSERT INTO `mp_user` VALUES (1435066199628091394, 'qjc', '2021-09-07 10:23:39', 'qjc', '2021-09-07 10:24:30', 1, 'dog', '888', '2021-02-01');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
